\section{Introduction}

	Every year a huge number \cite{sita} of bags are mishandled at the airports and causes not only a headache for passangers, but also the high rate of expenses for airline companies. There is a great need for tracking the bags at every possible stage in the airport (e.g. at check-in, sorters, gates, etc) and analyzing the data to improve the services. 

	The Lyngsoe Systems \cite{lyngsoe} company is using radio-frequency identification (RFID) technology for baggage tracking. They implemented a system to keep track of bags at the airports. This wireless and non-contact technology allows to collect data about bag in a reasonable distance. A number of RFID tag readers are deployed in strategical points of airport, as shown in figure \ref{fig:bag_path}. The numbered circles represent the RFID readers. Number 1 is the conveyor coming from check-in, number 2 is a sorter, 3 and 4 are gateways, and 5 is arrival. When a bag with a RFID microchip enters the area of a tag reader, the information is stored in a database. This data includes location and timestamp of the reader and therefore, indirectly the location of bag.
	
	%\begin{figure}[h!tb]
	%	\includegraphics[width=\columnwidth]{parts/images/bagPath}
	%	\caption{The path of a bag through baggage handling, with RFID readers.}
	%	\label{fig:bag_path}
	%\end{figure}
	\begin{figure}[h!tb]
		\includegraphics[width=\columnwidth]{parts/images/bagPathAAL}
		\caption{Example layout of a baggage transportation system.}
		\label{fig:bag_path}
	\end{figure}
	
	The collected data can be analyzed and used to improve the quality of service or reduce the cost of services. For this purpose we have designed and implemented a data warehouse solution for making a good analysis of bag tracking data and tried to find interesting results.
			
	% \textbf{comment! Short-long explanation of what we did in the research.}

	The structure of this research paper is as follows. Section 2 covers the related work in data warehousing domain. Section 3 covers explanational information of Lyngsoe System data. Section 4 gives brief information about how modelling of data warehouse schema was done. Section 5 includes explanation of ETL tool working and section 6 - evaluation of project. Finally, section 7 is for making a conclusion and section 8 for Future work.